@echo off
cd\
md Clarion2SQLFiles
cd Clarion2SQLFiles
REM md FROEND
md IICEXM
md IICREG

cd \ClarionViewer_v198

REM Set sPath=C:\IICDATA\FROEND\
REM Set tPath=C:\Clarion2SQLFiles\FROEND\

REM claview.exe %sPath%BAK_SCEN.DAT /e sql %tPath%BAK_SCEN.SQL /oem
REM claview.exe %sPath%GLOBALCT.DAT /e sql %tPath%GLOBALCT.SQL /oem
REM claview.exe %sPath%HORME_DT.DAT /e sql %tPath%HORME_DT.SQL /oem
REM claview.exe %sPath%LOGINS.DAT /e sql %tPath%LOGINS.SQL /oem
REM claview.exe %sPath%MODULECT.DAT /e sql %tPath%MODULECT.SQL /oem
REM claview.exe %sPath%MODULES.DAT /e sql %tPath%MODULES.SQL /oem
REM claview.exe %sPath%MOD_CFG.DAT /e sql %tPath%MOD_CFG.SQL /oem
REM claview.exe %sPath%MOD_POS.DAT /e sql %tPath%MOD_POS.SQL /oem
REM claview.exe %sPath%PRINTCNF.DAT /e sql %tPath%PRINTCNF.SQL /oem
REM claview.exe %sPath%PRN_AVL.DAT /e sql %tPath%PRN_AVL.SQL /oem
REM claview.exe %sPath%PROTECT.DAT /e sql %tPath%PROTECT.SQL /oem
REM claview.exe %sPath%SPOOLREP.DAT /e sql %tPath%SPOOLREP.SQL /oem
REM claview.exe %sPath%USERS.DAT /e sql %tPath%USERS.SQL /oem
REM claview.exe %sPath%USRALNTP.DAT /e sql %tPath%USRALNTP.SQL /oem
REM claview.exe %sPath%WST_CFG.DAT /e sql %tPath%WST_CFG.SQL /oem

REM cd \Clarion2SQLFiles\FROEND\
REM copy *.SQL C:\Clarion2SQLFiles\CreateStgIICDB1.SQL
REM For %f In (*.SQL) Do Type %f >> C:\Clarion2SQLFiles\CreateStgIICDB.SQL
REM cd \ClarionViewer_v198

Set sPath=C:\IICDATA\IICEXM\
Set tPath=C:\Clarion2SQLFiles\IICEXM\

claview.exe %sPath%CANDIDAT.DAT /e sql %tPath%CANDIDAT.SQL /oem
claview.exe %sPath%CAND_L_D.DAT /e sql %tPath%CAND_L_D.SQL /oem
claview.exe %sPath%CAND_L_H.DAT /e sql %tPath%CAND_L_H.SQL /oem
claview.exe %sPath%CAND_PRT.DAT /e sql %tPath%CAND_PRT.SQL /oem
claview.exe %sPath%CAND_SUB.DAT /e sql %tPath%CAND_SUB.SQL /oem
claview.exe %sPath%CNDSLPCY.DAT /e sql %tPath%CNDSLPCY.SQL /oem
claview.exe %sPath%CNDSLPGR.DAT /e sql %tPath%CNDSLPGR.SQL /oem
claview.exe %sPath%EX_CENTR.DAT /e sql %tPath%EX_CENTR.SQL /oem
claview.exe %sPath%EX_PERDS.DAT /e sql %tPath%EX_PERDS.SQL /oem
claview.exe %sPath%EX_SCH_D.DAT /e sql %tPath%EX_SCH_D.SQL /oem
claview.exe %sPath%EX_SCH_H.DAT /e sql %tPath%EX_SCH_H.SQL /oem
claview.exe %sPath%HOLD_CHG.DAT /e sql %tPath%HOLD_CHG.SQL /oem
claview.exe %sPath%LC_SCH_D.DAT /e sql %tPath%LC_SCH_D.SQL /oem
claview.exe %sPath%LC_SCH_H.DAT /e sql %tPath%LC_SCH_H.SQL /oem
claview.exe %sPath%LUTC_CLS.DAT /e sql %tPath%LUTC_CLS.SQL /oem
claview.exe %sPath%LUTC_CND.DAT /e sql %tPath%LUTC_CND.SQL /oem
claview.exe %sPath%LUTC_MTG.DAT /e sql %tPath%LUTC_MTG.SQL /oem
claview.exe %sPath%LUTC_PAR.DAT /e sql %tPath%LUTC_PAR.SQL /oem
claview.exe %sPath%LUTC_PRS.DAT /e sql %tPath%LUTC_PRS.SQL /oem
REM claview.exe %sPath%MODULECT.DAT /e sql %tPath%MODULECT.SQL /oem
REM claview.exe %sPath%MODULEPM.DAT /e sql %tPath%MODULEPM.SQL /oem
claview.exe %sPath%OLD_HOLD.DAT /e sql %tPath%OLD_HOLD.SQL /oem
claview.exe %sPath%PASC_HDR.DAT /e sql %tPath%PASC_HDR.SQL /oem
claview.exe %sPath%PASC_SUB.DAT /e sql %tPath%PASC_SUB.SQL /oem
claview.exe %sPath%PXS_CENT.DAT /e sql %tPath%PXS_CENT.SQL /oem
claview.exe %sPath%PXS_CND.DAT /e sql %tPath%PXS_CND.SQL /oem
claview.exe %sPath%PXS_PAR.DAT /e sql %tPath%PXS_PAR.SQL /oem
claview.exe %sPath%PXS_PRDS.DAT /e sql %tPath%PXS_PRDS.SQL /oem
claview.exe %sPath%PXS_SCH.DAT /e sql %tPath%PXS_SCH.SQL /oem
claview.exe %sPath%SUBJECTS.DAT /e sql %tPath%SUBJECTS.SQL /oem

cd \Clarion2SQLFiles\IICEXM\
copy *.SQL C:\Clarion2SQLFiles\CreateStgIICDB2.SQL
REM For %f In (*.SQL) Do Type %f >> C:\Clarion2SQLFiles\CreateStgIICDB.SQL
cd \ClarionViewer_v198

Set sPath=C:\IICDATA\IICREG\
Set tPath=C:\Clarion2SQLFiles\IICREG\

claview.exe %sPath%DISTRICT.DAT /e sql %tPath%DISTRICT.SQL /oem
claview.exe %sPath%IICMEM.DAT /e sql %tPath%IICMEM.SQL /oem
claview.exe %sPath%INSCOS.DAT /e sql %tPath%INSCOS.SQL /oem
claview.exe %sPath%MBRLAB.DAT /e sql %tPath%MBRLAB.SQL /oem
claview.exe %sPath%MEMBERS.DAT /e sql %tPath%MEMBERS.SQL /oem
claview.exe %sPath%MODULECT.DAT /e sql %tPath%MODULECT.SQL /oem
claview.exe %sPath%MODULEPM.DAT /e sql %tPath%MODULEPM.SQL /oem

cd \Clarion2SQLFiles\IICREG\
copy *.SQL C:\Clarion2SQLFiles\CreateStgIICDB3.SQL
REM For %f In (*.SQL) Do Type %f >> C:\Clarion2SQLFiles\CreateStgIICDB.SQL

cd \Clarion2SQLFiles\
copy *.SQL C:\Clarion2SQLFiles\CreateStgIICDB.SQL

cd\

pause